Emilio Wright ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	13

About Me

About Me

Not much happening here, yet.

Analytics

52

Posts

196

Visits

346

Points

Nov 16, 2021

Join Date

Dec 20, 2023

Last Active

Reactions

• Insightful 1

  1
• Vote Up 6

  6
• Awesome 7

  7

• Activity
• Discussions7
• Comments45

• Re: Calculating elapsed time in percentage #UNPARSEABLE

  Emilio Wright

  02/08/23
  @malik alrayes Same as Brent, I just copied your formula since I know that depending on your location, the delimiter could be different.
  1 ·

• Re: Automatic RYGB Lights

  Emilio Wright

  02/03/23
  @Jeffrey Wagemans I created the formula based on your table, although it has gaps and you will begin to notice them when users begin to use the fields. I found one but have not changed the formula si…
  1 ·

• Re: Dynamic Dropdowns

  Emilio Wright

  02/03/23
  @Chris Shifflett @Ryan Sides I created a python script that can update contact list dropdowns (or any type of dropdown column) based on a list of sheets provided. It does take about 5-10 seconds per …
  1 ·

• Re: Counting rows that contain specific years

  Emilio Wright

  02/02/23
  @RebTrachs Okay. Thank you for the clarification. I always have VS Code open because I use the Smartsheet API, so I tend to always create my formulas there because I can clearly see column names and …
  1 ·

• Re: Counting rows that contain specific years

  Emilio Wright

  02/02/23
  @RebTrachs This should do it. You need the IFERROR() to catch any blank cells since we are using a range and the @cell value. =COUNTIF([Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2023)
  3 ·

Next